Tutorial - Generate a DomoStats dataset using DomoLibrary

DomoStats
MagicETL
Author

Jae Wilson

Published

November 28, 2023

# pip install domolibrary
import os

domo_instance = os.environ['DOMO_INSTANCE']
domo_access_token = os.environ['DOMO_ACCESS_TOKEN']
import domolibrary.client.DomoAuth as dmda

auth = dmda.DomoTokenAuth(
    domo_instance=domo_instance,
    domo_access_token=domo_access_token
)

await auth.print_is_token()
🎉 token_auth token retrieved from domo-community ⚙️
True
import domolibrary.classes.DomoDatacenter as dmdc

domo_datacenter = dmdc.DomoDatacenter(auth=auth)

dataflows_ls = await domo_datacenter.search_datacenter(
    auth=auth,
    entity_type="DATAFLOW",
    additional_filters_ls=[
        {
            "filterType": "term",
            "field": "data_flow_type",
            "value": "MAGIC",
            "name": "Magic ETL v2",
            "not": False,
        }
    ],
)

dataflows_ls[0]
{'entityType': 'dataflow',
 'databaseId': '131',
 'searchId': {'indexName': None,
  'databaseId': '131',
  'customer': 'mmmm-0012-0200',
  'entityType': 'dataflow'},
 'createDate': 1678147044000,
 'lastModified': 1678147835000,
 'lastIndexed': 1680574033100,
 'highlightedFields': {},
 'language': 'English',
 'requestAccess': False,
 'score': 10.000001,
 'name': 'BeastModesGovernance_01_AccumulateHistory',
 'description': '',
 'ownedById': '1893952720',
 'ownedByName': 'Jae Wilson1',
 'tags': [],
 'lastRunDate': 1678147669000,
 'inputDatasets': [{'name': 'Governance_Beast Modes',
   'id': 'b7998b45-ccb5-4183-830e-8c2bdd489fd0'}],
 'outputDatasets': [{'name': 'Governance_BeastMode_historical',
   'id': 'e6559952-30ce-41a1-b831-f29ebe95d6e5'}],
 'runCount': 2,
 'successRate': 1.0,
 'dataFlowType': 'MAGIC',
 'status': 'SUCCESS',
 'deleted': False,
 'passwordProtected': False,
 'abandoned': False,
 'owners': [{'id': '1893952720',
   'type': 'USER',
   'displayName': 'Jae Wilson1'}],
 'ownersLocalized': {'localizedMessage': 'Jae Wilson1', 'count': 1},
 'paused': False,
 'useGraphUI': False,
 'permissionMask': 31,
 'winnerText': 'BeastModesGovernance_01_AccumulateHistory',
 'inputCount': 1,
 'statusOrderPriority': 70,
 'outputCount': 1,
 'ownedByType': 'USER',
 'customer': 'mmmm-0012-0200'}
dataflow_ids = [dataflow.get("databaseId") for dataflow in dataflows_ls]
dataflow_ids[0:5]
['131', '227', '37', '185', '38']
import domolibrary.classes.DomoDataflow as dmdf
import asyncio

dataflow_definition_ls = await asyncio.gather(
    *[
        dmdf.DomoDataflow.get_by_id(dataflow_id=dataflow_id, auth=auth)
        for dataflow_id in dataflow_ids
    ]
)

domo_dataflow = dataflow_definition_ls[0]
domo_dataflow
DomoDataflow(id=131, name='BeastModesGovernance_01_AccumulateHistory', owner=None, description=None, tags=None, actions=[DomoDataflow_Action(id='40554fc4-428a-4117-8820-b3f4f4927021', type='LoadFromVault', name='Governance_Beast Modes', datasource_id='b7998b45-ccb5-4183-830e-8c2bdd489fd0', sql=None, depends_on=None, parent_actions=None), DomoDataflow_Action(id='05082103-d42e-49ab-a66e-bd31b4c0e3df', type='ExpressionEvaluator', name='Add Formula', datasource_id=None, sql=None, depends_on=['40554fc4-428a-4117-8820-b3f4f4927021'], parent_actions=[DomoDataflow_Action(id='40554fc4-428a-4117-8820-b3f4f4927021', type='LoadFromVault', name='Governance_Beast Modes', datasource_id='b7998b45-ccb5-4183-830e-8c2bdd489fd0', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='fe77761b-eb11-4491-b19c-ebb56d009b76', type='PublishToVault', name='Governance_BeastMode_historical', datasource_id='e6559952-30ce-41a1-b831-f29ebe95d6e5', sql=None, depends_on=['05082103-d42e-49ab-a66e-bd31b4c0e3df'], parent_actions=[DomoDataflow_Action(id='05082103-d42e-49ab-a66e-bd31b4c0e3df', type='ExpressionEvaluator', name='Add Formula', datasource_id=None, sql=None, depends_on=['40554fc4-428a-4117-8820-b3f4f4927021'], parent_actions=[DomoDataflow_Action(id='40554fc4-428a-4117-8820-b3f4f4927021', type='LoadFromVault', name='Governance_Beast Modes', datasource_id='b7998b45-ccb5-4183-830e-8c2bdd489fd0', sql=None, depends_on=None, parent_actions=None)])])], version_id=None, version_number=None, versions=None, History=DomoDataflow_History(execution_history=None), Lineage=DomoLineage(parent_type='DATAFLOW', parent_id=131))
domo_dataflow = await dmdf.DomoDataflow.get_by_id(dataflow_id=9, auth=auth)
domo_dataflow
DomoDataflow(id=9, name='DOMO Covid Datasets', owner=None, description=None, tags=None, actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None), DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None), DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])]), DomoDataflow_Action(id='3224b938-e977-40ea-bb85-c6784d13fa95', type='NumericCalculator', name='Active Cases', datasource_id=None, sql=None, depends_on=['59e6226d-507f-4cff-86b1-f024499173aa'], parent_actions=[DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])]), DomoDataflow_Action(id='39a7a4ba-8bc3-4141-ac44-ada9ecee380e', type='SelectValues', name='Select Columns', datasource_id=None, sql=None, depends_on=['3224b938-e977-40ea-bb85-c6784d13fa95'], parent_actions=[DomoDataflow_Action(id='3224b938-e977-40ea-bb85-c6784d13fa95', type='NumericCalculator', name='Active Cases', datasource_id=None, sql=None, depends_on=['59e6226d-507f-4cff-86b1-f024499173aa'], parent_actions=[DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='a55f2e60-9418-4291-8272-141be6193740', type='PublishToVault', name='DOMO_Covid_Current Snapshot', datasource_id='e0bbe9ec-6ccf-428b-b18b-a2405cedbe4b', sql=None, depends_on=['39a7a4ba-8bc3-4141-ac44-ada9ecee380e'], parent_actions=[DomoDataflow_Action(id='39a7a4ba-8bc3-4141-ac44-ada9ecee380e', type='SelectValues', name='Select Columns', datasource_id=None, sql=None, depends_on=['3224b938-e977-40ea-bb85-c6784d13fa95'], parent_actions=[DomoDataflow_Action(id='3224b938-e977-40ea-bb85-c6784d13fa95', type='NumericCalculator', name='Active Cases', datasource_id=None, sql=None, depends_on=['59e6226d-507f-4cff-86b1-f024499173aa'], parent_actions=[DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='4f77e294-4673-46b5-8744-8317eeae39a7', type='SelectValues', name='Prep for Pivot', datasource_id=None, sql=None, depends_on=['3224b938-e977-40ea-bb85-c6784d13fa95'], parent_actions=[DomoDataflow_Action(id='3224b938-e977-40ea-bb85-c6784d13fa95', type='NumericCalculator', name='Active Cases', datasource_id=None, sql=None, depends_on=['59e6226d-507f-4cff-86b1-f024499173aa'], parent_actions=[DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='9e6fef1a-2428-4c70-ab47-9aaf80a035aa', type='NormalizeAll', name='Dynamic Unpivot', datasource_id=None, sql=None, depends_on=['4f77e294-4673-46b5-8744-8317eeae39a7'], parent_actions=[DomoDataflow_Action(id='4f77e294-4673-46b5-8744-8317eeae39a7', type='SelectValues', name='Prep for Pivot', datasource_id=None, sql=None, depends_on=['3224b938-e977-40ea-bb85-c6784d13fa95'], parent_actions=[DomoDataflow_Action(id='3224b938-e977-40ea-bb85-c6784d13fa95', type='NumericCalculator', name='Active Cases', datasource_id=None, sql=None, depends_on=['59e6226d-507f-4cff-86b1-f024499173aa'], parent_actions=[DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='58109dc0-37e6-4893-9ba0-5ed5b3c1eaa8', type='PublishToVault', name='DOMO_Covid_Current Snapshot_Collapsed', datasource_id='be14b18c-7844-48e4-8acc-0878c3dc96b0', sql=None, depends_on=['9e6fef1a-2428-4c70-ab47-9aaf80a035aa'], parent_actions=[DomoDataflow_Action(id='9e6fef1a-2428-4c70-ab47-9aaf80a035aa', type='NormalizeAll', name='Dynamic Unpivot', datasource_id=None, sql=None, depends_on=['4f77e294-4673-46b5-8744-8317eeae39a7'], parent_actions=[DomoDataflow_Action(id='4f77e294-4673-46b5-8744-8317eeae39a7', type='SelectValues', name='Prep for Pivot', datasource_id=None, sql=None, depends_on=['3224b938-e977-40ea-bb85-c6784d13fa95'], parent_actions=[DomoDataflow_Action(id='3224b938-e977-40ea-bb85-c6784d13fa95', type='NumericCalculator', name='Active Cases', datasource_id=None, sql=None, depends_on=['59e6226d-507f-4cff-86b1-f024499173aa'], parent_actions=[DomoDataflow_Action(id='59e6226d-507f-4cff-86b1-f024499173aa', type='NumericCalculator', name='Resolved Cases', datasource_id=None, sql=None, depends_on=['6e3ec9a4-470b-4fe4-8e8a-bd954b681df4'], parent_actions=[DomoDataflow_Action(id='6e3ec9a4-470b-4fe4-8e8a-bd954b681df4', type='DateCalculator', name='Days Since...', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])]), DomoDataflow_Action(id='2037eb8f-c88c-4d9f-8d14-ae591a27b627', type='WindowAction', name='Deaths', datasource_id=None, sql=None, depends_on=['69cecc30-a170-432d-8367-1e3c2d362419'], parent_actions=[DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])]), DomoDataflow_Action(id='0c791afe-0acb-4821-8781-ddd5d51c850a', type='WindowAction', name='Recovered', datasource_id=None, sql=None, depends_on=['2037eb8f-c88c-4d9f-8d14-ae591a27b627'], parent_actions=[DomoDataflow_Action(id='2037eb8f-c88c-4d9f-8d14-ae591a27b627', type='WindowAction', name='Deaths', datasource_id=None, sql=None, depends_on=['69cecc30-a170-432d-8367-1e3c2d362419'], parent_actions=[DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', type='SelectValues', name='Ranks', datasource_id=None, sql=None, depends_on=['0c791afe-0acb-4821-8781-ddd5d51c850a'], parent_actions=[DomoDataflow_Action(id='0c791afe-0acb-4821-8781-ddd5d51c850a', type='WindowAction', name='Recovered', datasource_id=None, sql=None, depends_on=['2037eb8f-c88c-4d9f-8d14-ae591a27b627'], parent_actions=[DomoDataflow_Action(id='2037eb8f-c88c-4d9f-8d14-ae591a27b627', type='WindowAction', name='Deaths', datasource_id=None, sql=None, depends_on=['69cecc30-a170-432d-8367-1e3c2d362419'], parent_actions=[DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])]), DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])]), DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='43029ef0-9519-49c6-80c2-2f885e662221', type='WindowAction', name='Recovered 1', datasource_id=None, sql=None, depends_on=['16bae147-462b-4547-94b2-8075aab0a2fb'], parent_actions=[DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='eeecc67b-34c4-4929-a4e3-34058aba039a', type='SelectValues', name='Ranks 1', datasource_id=None, sql=None, depends_on=['43029ef0-9519-49c6-80c2-2f885e662221'], parent_actions=[DomoDataflow_Action(id='43029ef0-9519-49c6-80c2-2f885e662221', type='WindowAction', name='Recovered 1', datasource_id=None, sql=None, depends_on=['16bae147-462b-4547-94b2-8075aab0a2fb'], parent_actions=[DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])]), DomoDataflow_Action(id='1d3e790a-dabf-45ba-849e-74996d7a03c9', type='NumericCalculator', name='Resolved Cases 1', datasource_id=None, sql=None, depends_on=['660e1e8c-0d62-4e8c-9784-d4555ae46167'], parent_actions=[DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])])]), DomoDataflow_Action(id='dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f', type='NumericCalculator', name='Active Cases 1', datasource_id=None, sql=None, depends_on=['1d3e790a-dabf-45ba-849e-74996d7a03c9'], parent_actions=[DomoDataflow_Action(id='1d3e790a-dabf-45ba-849e-74996d7a03c9', type='NumericCalculator', name='Resolved Cases 1', datasource_id=None, sql=None, depends_on=['660e1e8c-0d62-4e8c-9784-d4555ae46167'], parent_actions=[DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='64d116fa-b2fb-40ed-a834-5e98c541eb09', type='MergeJoin', name='State Rank', datasource_id=None, sql=None, depends_on=['eeecc67b-34c4-4929-a4e3-34058aba039a', 'dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f'], parent_actions=[DomoDataflow_Action(id='eeecc67b-34c4-4929-a4e3-34058aba039a', type='SelectValues', name='Ranks 1', datasource_id=None, sql=None, depends_on=['43029ef0-9519-49c6-80c2-2f885e662221'], parent_actions=[DomoDataflow_Action(id='43029ef0-9519-49c6-80c2-2f885e662221', type='WindowAction', name='Recovered 1', datasource_id=None, sql=None, depends_on=['16bae147-462b-4547-94b2-8075aab0a2fb'], parent_actions=[DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f', type='NumericCalculator', name='Active Cases 1', datasource_id=None, sql=None, depends_on=['1d3e790a-dabf-45ba-849e-74996d7a03c9'], parent_actions=[DomoDataflow_Action(id='1d3e790a-dabf-45ba-849e-74996d7a03c9', type='NumericCalculator', name='Resolved Cases 1', datasource_id=None, sql=None, depends_on=['660e1e8c-0d62-4e8c-9784-d4555ae46167'], parent_actions=[DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='a660c21b-b639-4f8d-b0d1-7024fea1056e', type='MergeJoin', name='Country Rank', datasource_id=None, sql=None, depends_on=['95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', '64d116fa-b2fb-40ed-a834-5e98c541eb09'], parent_actions=[DomoDataflow_Action(id='95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', type='SelectValues', name='Ranks', datasource_id=None, sql=None, depends_on=['0c791afe-0acb-4821-8781-ddd5d51c850a'], parent_actions=[DomoDataflow_Action(id='0c791afe-0acb-4821-8781-ddd5d51c850a', type='WindowAction', name='Recovered', datasource_id=None, sql=None, depends_on=['2037eb8f-c88c-4d9f-8d14-ae591a27b627'], parent_actions=[DomoDataflow_Action(id='2037eb8f-c88c-4d9f-8d14-ae591a27b627', type='WindowAction', name='Deaths', datasource_id=None, sql=None, depends_on=['69cecc30-a170-432d-8367-1e3c2d362419'], parent_actions=[DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='64d116fa-b2fb-40ed-a834-5e98c541eb09', type='MergeJoin', name='State Rank', datasource_id=None, sql=None, depends_on=['eeecc67b-34c4-4929-a4e3-34058aba039a', 'dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f'], parent_actions=[DomoDataflow_Action(id='eeecc67b-34c4-4929-a4e3-34058aba039a', type='SelectValues', name='Ranks 1', datasource_id=None, sql=None, depends_on=['43029ef0-9519-49c6-80c2-2f885e662221'], parent_actions=[DomoDataflow_Action(id='43029ef0-9519-49c6-80c2-2f885e662221', type='WindowAction', name='Recovered 1', datasource_id=None, sql=None, depends_on=['16bae147-462b-4547-94b2-8075aab0a2fb'], parent_actions=[DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f', type='NumericCalculator', name='Active Cases 1', datasource_id=None, sql=None, depends_on=['1d3e790a-dabf-45ba-849e-74996d7a03c9'], parent_actions=[DomoDataflow_Action(id='1d3e790a-dabf-45ba-849e-74996d7a03c9', type='NumericCalculator', name='Resolved Cases 1', datasource_id=None, sql=None, depends_on=['660e1e8c-0d62-4e8c-9784-d4555ae46167'], parent_actions=[DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='5dc2fda6-902b-4c68-ba7d-1216b54fc1f6', type='SelectValues', name='Select Columns 2', datasource_id=None, sql=None, depends_on=['a660c21b-b639-4f8d-b0d1-7024fea1056e'], parent_actions=[DomoDataflow_Action(id='a660c21b-b639-4f8d-b0d1-7024fea1056e', type='MergeJoin', name='Country Rank', datasource_id=None, sql=None, depends_on=['95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', '64d116fa-b2fb-40ed-a834-5e98c541eb09'], parent_actions=[DomoDataflow_Action(id='95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', type='SelectValues', name='Ranks', datasource_id=None, sql=None, depends_on=['0c791afe-0acb-4821-8781-ddd5d51c850a'], parent_actions=[DomoDataflow_Action(id='0c791afe-0acb-4821-8781-ddd5d51c850a', type='WindowAction', name='Recovered', datasource_id=None, sql=None, depends_on=['2037eb8f-c88c-4d9f-8d14-ae591a27b627'], parent_actions=[DomoDataflow_Action(id='2037eb8f-c88c-4d9f-8d14-ae591a27b627', type='WindowAction', name='Deaths', datasource_id=None, sql=None, depends_on=['69cecc30-a170-432d-8367-1e3c2d362419'], parent_actions=[DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='64d116fa-b2fb-40ed-a834-5e98c541eb09', type='MergeJoin', name='State Rank', datasource_id=None, sql=None, depends_on=['eeecc67b-34c4-4929-a4e3-34058aba039a', 'dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f'], parent_actions=[DomoDataflow_Action(id='eeecc67b-34c4-4929-a4e3-34058aba039a', type='SelectValues', name='Ranks 1', datasource_id=None, sql=None, depends_on=['43029ef0-9519-49c6-80c2-2f885e662221'], parent_actions=[DomoDataflow_Action(id='43029ef0-9519-49c6-80c2-2f885e662221', type='WindowAction', name='Recovered 1', datasource_id=None, sql=None, depends_on=['16bae147-462b-4547-94b2-8075aab0a2fb'], parent_actions=[DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f', type='NumericCalculator', name='Active Cases 1', datasource_id=None, sql=None, depends_on=['1d3e790a-dabf-45ba-849e-74996d7a03c9'], parent_actions=[DomoDataflow_Action(id='1d3e790a-dabf-45ba-849e-74996d7a03c9', type='NumericCalculator', name='Resolved Cases 1', datasource_id=None, sql=None, depends_on=['660e1e8c-0d62-4e8c-9784-d4555ae46167'], parent_actions=[DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])])])])])])]), DomoDataflow_Action(id='a3000ccf-ad34-4b11-a25e-2e6acb0e50b5', type='PublishToVault', name='DOMO_Covid_Time Series', datasource_id='bea90814-7772-47ef-b6c9-7e5368d41b06', sql=None, depends_on=['5dc2fda6-902b-4c68-ba7d-1216b54fc1f6'], parent_actions=[DomoDataflow_Action(id='5dc2fda6-902b-4c68-ba7d-1216b54fc1f6', type='SelectValues', name='Select Columns 2', datasource_id=None, sql=None, depends_on=['a660c21b-b639-4f8d-b0d1-7024fea1056e'], parent_actions=[DomoDataflow_Action(id='a660c21b-b639-4f8d-b0d1-7024fea1056e', type='MergeJoin', name='Country Rank', datasource_id=None, sql=None, depends_on=['95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', '64d116fa-b2fb-40ed-a834-5e98c541eb09'], parent_actions=[DomoDataflow_Action(id='95f6b96d-af65-4d3b-8e3a-94ce7f2e4f64', type='SelectValues', name='Ranks', datasource_id=None, sql=None, depends_on=['0c791afe-0acb-4821-8781-ddd5d51c850a'], parent_actions=[DomoDataflow_Action(id='0c791afe-0acb-4821-8781-ddd5d51c850a', type='WindowAction', name='Recovered', datasource_id=None, sql=None, depends_on=['2037eb8f-c88c-4d9f-8d14-ae591a27b627'], parent_actions=[DomoDataflow_Action(id='2037eb8f-c88c-4d9f-8d14-ae591a27b627', type='WindowAction', name='Deaths', datasource_id=None, sql=None, depends_on=['69cecc30-a170-432d-8367-1e3c2d362419'], parent_actions=[DomoDataflow_Action(id='69cecc30-a170-432d-8367-1e3c2d362419', type='WindowAction', name='Confirmed', datasource_id=None, sql=None, depends_on=['d2ef7338-17ee-4f9c-a93b-b268605ea81e'], parent_actions=[DomoDataflow_Action(id='d2ef7338-17ee-4f9c-a93b-b268605ea81e', type='GroupBy', name='Country Summary', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='64d116fa-b2fb-40ed-a834-5e98c541eb09', type='MergeJoin', name='State Rank', datasource_id=None, sql=None, depends_on=['eeecc67b-34c4-4929-a4e3-34058aba039a', 'dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f'], parent_actions=[DomoDataflow_Action(id='eeecc67b-34c4-4929-a4e3-34058aba039a', type='SelectValues', name='Ranks 1', datasource_id=None, sql=None, depends_on=['43029ef0-9519-49c6-80c2-2f885e662221'], parent_actions=[DomoDataflow_Action(id='43029ef0-9519-49c6-80c2-2f885e662221', type='WindowAction', name='Recovered 1', datasource_id=None, sql=None, depends_on=['16bae147-462b-4547-94b2-8075aab0a2fb'], parent_actions=[DomoDataflow_Action(id='16bae147-462b-4547-94b2-8075aab0a2fb', type='WindowAction', name='Deaths 1', datasource_id=None, sql=None, depends_on=['551ebf46-d0ac-4210-83cd-a50049b2b61d'], parent_actions=[DomoDataflow_Action(id='551ebf46-d0ac-4210-83cd-a50049b2b61d', type='WindowAction', name='Confirmed 1', datasource_id=None, sql=None, depends_on=['30d11b8a-eed9-4037-aa2c-03c83c3f66b8'], parent_actions=[DomoDataflow_Action(id='30d11b8a-eed9-4037-aa2c-03c83c3f66b8', type='GroupBy', name='State Summary', datasource_id=None, sql=None, depends_on=['57da148c-17f8-495d-b81d-2db18e1073dc'], parent_actions=[DomoDataflow_Action(id='57da148c-17f8-495d-b81d-2db18e1073dc', type='Filter', name='United States', datasource_id=None, sql=None, depends_on=['0e192d7e-280b-4c4d-bde2-f0f3adb1e213'], parent_actions=[DomoDataflow_Action(id='0e192d7e-280b-4c4d-bde2-f0f3adb1e213', type='LoadFromVault', name='DOMO Covid Current Snapshot Tracker Data', datasource_id='b034f19e-16d5-4cb3-afac-b72c8e6a79fd', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f', type='NumericCalculator', name='Active Cases 1', datasource_id=None, sql=None, depends_on=['1d3e790a-dabf-45ba-849e-74996d7a03c9'], parent_actions=[DomoDataflow_Action(id='1d3e790a-dabf-45ba-849e-74996d7a03c9', type='NumericCalculator', name='Resolved Cases 1', datasource_id=None, sql=None, depends_on=['660e1e8c-0d62-4e8c-9784-d4555ae46167'], parent_actions=[DomoDataflow_Action(id='660e1e8c-0d62-4e8c-9784-d4555ae46167', type='DateCalculator', name='Days Since... 2', datasource_id=None, sql=None, depends_on=['a1d07083-d1ca-41e9-8be2-f13596df03c3'], parent_actions=[DomoDataflow_Action(id='a1d07083-d1ca-41e9-8be2-f13596df03c3', type='ValueMapper', name='Value Mapper', datasource_id=None, sql=None, depends_on=['96d04e4b-dc72-479c-b84b-ad0b74ada085'], parent_actions=[DomoDataflow_Action(id='96d04e4b-dc72-479c-b84b-ad0b74ada085', type='LoadFromVault', name='DOMO Covid Time Series Tracker Data', datasource_id='dcad2f50-e65e-4259-a9e8-214a3d1e18a7', sql=None, depends_on=None, parent_actions=None)])])])])])])])]), DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None), DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])]), DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])]), DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='02a1f8dd-2b0a-4193-9c54-8d4fc19261cc', type='DateCalculator', name='Snapshot Age 1', datasource_id=None, sql=None, depends_on=['250bf67d-8882-4078-a7d4-aa6dda1a1635'], parent_actions=[DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])]), DomoDataflow_Action(id='709cc8dc-77b6-46c9-9c23-1e8a7cd44203', type='ValueMapper', name='Value Mapper 1', datasource_id=None, sql=None, depends_on=['02a1f8dd-2b0a-4193-9c54-8d4fc19261cc'], parent_actions=[DomoDataflow_Action(id='02a1f8dd-2b0a-4193-9c54-8d4fc19261cc', type='DateCalculator', name='Snapshot Age 1', datasource_id=None, sql=None, depends_on=['250bf67d-8882-4078-a7d4-aa6dda1a1635'], parent_actions=[DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])])]), DomoDataflow_Action(id='a72904d6-88d3-4e47-838b-9a0087d9b2be', type='ConcatFields', name='State | County 1', datasource_id=None, sql=None, depends_on=['709cc8dc-77b6-46c9-9c23-1e8a7cd44203'], parent_actions=[DomoDataflow_Action(id='709cc8dc-77b6-46c9-9c23-1e8a7cd44203', type='ValueMapper', name='Value Mapper 1', datasource_id=None, sql=None, depends_on=['02a1f8dd-2b0a-4193-9c54-8d4fc19261cc'], parent_actions=[DomoDataflow_Action(id='02a1f8dd-2b0a-4193-9c54-8d4fc19261cc', type='DateCalculator', name='Snapshot Age 1', datasource_id=None, sql=None, depends_on=['250bf67d-8882-4078-a7d4-aa6dda1a1635'], parent_actions=[DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])])])]), DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)]), DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])]), DomoDataflow_Action(id='0363ec9b-6a88-4914-baa1-80983f03289c', type='WindowAction', name='Deaths 2', datasource_id=None, sql=None, depends_on=['0d438931-d91a-43ff-8b79-654e6925c4be'], parent_actions=[DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])]), DomoDataflow_Action(id='17e224ee-3f06-4ad1-ad6a-1226af11f5d9', type='WindowAction', name='Recovered 2', datasource_id=None, sql=None, depends_on=['0363ec9b-6a88-4914-baa1-80983f03289c'], parent_actions=[DomoDataflow_Action(id='0363ec9b-6a88-4914-baa1-80983f03289c', type='WindowAction', name='Deaths 2', datasource_id=None, sql=None, depends_on=['0d438931-d91a-43ff-8b79-654e6925c4be'], parent_actions=[DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])]), DomoDataflow_Action(id='2d699db0-8a70-4671-837e-3b9fd03152c8', type='ConcatFields', name='State | County', datasource_id=None, sql=None, depends_on=['17e224ee-3f06-4ad1-ad6a-1226af11f5d9'], parent_actions=[DomoDataflow_Action(id='17e224ee-3f06-4ad1-ad6a-1226af11f5d9', type='WindowAction', name='Recovered 2', datasource_id=None, sql=None, depends_on=['0363ec9b-6a88-4914-baa1-80983f03289c'], parent_actions=[DomoDataflow_Action(id='0363ec9b-6a88-4914-baa1-80983f03289c', type='WindowAction', name='Deaths 2', datasource_id=None, sql=None, depends_on=['0d438931-d91a-43ff-8b79-654e6925c4be'], parent_actions=[DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])]), DomoDataflow_Action(id='64244d26-fc99-459b-966a-ceb3f412ed31', type='MergeJoin', name='Join Data', datasource_id=None, sql=None, depends_on=['a72904d6-88d3-4e47-838b-9a0087d9b2be', '2d699db0-8a70-4671-837e-3b9fd03152c8'], parent_actions=[DomoDataflow_Action(id='a72904d6-88d3-4e47-838b-9a0087d9b2be', type='ConcatFields', name='State | County 1', datasource_id=None, sql=None, depends_on=['709cc8dc-77b6-46c9-9c23-1e8a7cd44203'], parent_actions=[DomoDataflow_Action(id='709cc8dc-77b6-46c9-9c23-1e8a7cd44203', type='ValueMapper', name='Value Mapper 1', datasource_id=None, sql=None, depends_on=['02a1f8dd-2b0a-4193-9c54-8d4fc19261cc'], parent_actions=[DomoDataflow_Action(id='02a1f8dd-2b0a-4193-9c54-8d4fc19261cc', type='DateCalculator', name='Snapshot Age 1', datasource_id=None, sql=None, depends_on=['250bf67d-8882-4078-a7d4-aa6dda1a1635'], parent_actions=[DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])])])]), DomoDataflow_Action(id='2d699db0-8a70-4671-837e-3b9fd03152c8', type='ConcatFields', name='State | County', datasource_id=None, sql=None, depends_on=['17e224ee-3f06-4ad1-ad6a-1226af11f5d9'], parent_actions=[DomoDataflow_Action(id='17e224ee-3f06-4ad1-ad6a-1226af11f5d9', type='WindowAction', name='Recovered 2', datasource_id=None, sql=None, depends_on=['0363ec9b-6a88-4914-baa1-80983f03289c'], parent_actions=[DomoDataflow_Action(id='0363ec9b-6a88-4914-baa1-80983f03289c', type='WindowAction', name='Deaths 2', datasource_id=None, sql=None, depends_on=['0d438931-d91a-43ff-8b79-654e6925c4be'], parent_actions=[DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])]), DomoDataflow_Action(id='5347a8d3-48de-4799-af32-311ba4936c23', type='SelectValues', name='Select Columns 4', datasource_id=None, sql=None, depends_on=['64244d26-fc99-459b-966a-ceb3f412ed31'], parent_actions=[DomoDataflow_Action(id='64244d26-fc99-459b-966a-ceb3f412ed31', type='MergeJoin', name='Join Data', datasource_id=None, sql=None, depends_on=['a72904d6-88d3-4e47-838b-9a0087d9b2be', '2d699db0-8a70-4671-837e-3b9fd03152c8'], parent_actions=[DomoDataflow_Action(id='a72904d6-88d3-4e47-838b-9a0087d9b2be', type='ConcatFields', name='State | County 1', datasource_id=None, sql=None, depends_on=['709cc8dc-77b6-46c9-9c23-1e8a7cd44203'], parent_actions=[DomoDataflow_Action(id='709cc8dc-77b6-46c9-9c23-1e8a7cd44203', type='ValueMapper', name='Value Mapper 1', datasource_id=None, sql=None, depends_on=['02a1f8dd-2b0a-4193-9c54-8d4fc19261cc'], parent_actions=[DomoDataflow_Action(id='02a1f8dd-2b0a-4193-9c54-8d4fc19261cc', type='DateCalculator', name='Snapshot Age 1', datasource_id=None, sql=None, depends_on=['250bf67d-8882-4078-a7d4-aa6dda1a1635'], parent_actions=[DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])])])]), DomoDataflow_Action(id='2d699db0-8a70-4671-837e-3b9fd03152c8', type='ConcatFields', name='State | County', datasource_id=None, sql=None, depends_on=['17e224ee-3f06-4ad1-ad6a-1226af11f5d9'], parent_actions=[DomoDataflow_Action(id='17e224ee-3f06-4ad1-ad6a-1226af11f5d9', type='WindowAction', name='Recovered 2', datasource_id=None, sql=None, depends_on=['0363ec9b-6a88-4914-baa1-80983f03289c'], parent_actions=[DomoDataflow_Action(id='0363ec9b-6a88-4914-baa1-80983f03289c', type='WindowAction', name='Deaths 2', datasource_id=None, sql=None, depends_on=['0d438931-d91a-43ff-8b79-654e6925c4be'], parent_actions=[DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])]), DomoDataflow_Action(id='31d9273c-3bf1-4046-8594-1bec09a0f83f', type='PublishToVault', name='DOMO_Covid_Time Series_County', datasource_id='dde1d15a-04d1-42c7-88bb-10563e42be01', sql=None, depends_on=['5347a8d3-48de-4799-af32-311ba4936c23'], parent_actions=[DomoDataflow_Action(id='5347a8d3-48de-4799-af32-311ba4936c23', type='SelectValues', name='Select Columns 4', datasource_id=None, sql=None, depends_on=['64244d26-fc99-459b-966a-ceb3f412ed31'], parent_actions=[DomoDataflow_Action(id='64244d26-fc99-459b-966a-ceb3f412ed31', type='MergeJoin', name='Join Data', datasource_id=None, sql=None, depends_on=['a72904d6-88d3-4e47-838b-9a0087d9b2be', '2d699db0-8a70-4671-837e-3b9fd03152c8'], parent_actions=[DomoDataflow_Action(id='a72904d6-88d3-4e47-838b-9a0087d9b2be', type='ConcatFields', name='State | County 1', datasource_id=None, sql=None, depends_on=['709cc8dc-77b6-46c9-9c23-1e8a7cd44203'], parent_actions=[DomoDataflow_Action(id='709cc8dc-77b6-46c9-9c23-1e8a7cd44203', type='ValueMapper', name='Value Mapper 1', datasource_id=None, sql=None, depends_on=['02a1f8dd-2b0a-4193-9c54-8d4fc19261cc'], parent_actions=[DomoDataflow_Action(id='02a1f8dd-2b0a-4193-9c54-8d4fc19261cc', type='DateCalculator', name='Snapshot Age 1', datasource_id=None, sql=None, depends_on=['250bf67d-8882-4078-a7d4-aa6dda1a1635'], parent_actions=[DomoDataflow_Action(id='250bf67d-8882-4078-a7d4-aa6dda1a1635', type='NumericCalculator', name='Active Cases 2', datasource_id=None, sql=None, depends_on=['dac9af4e-a203-47f5-9493-ec46d834a51f'], parent_actions=[DomoDataflow_Action(id='dac9af4e-a203-47f5-9493-ec46d834a51f', type='NumericCalculator', name='Resolved Cases 2', datasource_id=None, sql=None, depends_on=['cebf2fb3-75e3-48ee-bfe5-2af9927cb581'], parent_actions=[DomoDataflow_Action(id='cebf2fb3-75e3-48ee-bfe5-2af9927cb581', type='ValueMapper', name='Null or 0 Long', datasource_id=None, sql=None, depends_on=['fe46f53d-d10e-4e1e-b341-4d18f565e83b'], parent_actions=[DomoDataflow_Action(id='fe46f53d-d10e-4e1e-b341-4d18f565e83b', type='ValueMapper', name='Null or 0 Lat', datasource_id=None, sql=None, depends_on=['d652deb2-cd3e-462d-9627-2f72425e05cf'], parent_actions=[DomoDataflow_Action(id='d652deb2-cd3e-462d-9627-2f72425e05cf', type='ValueMapper', name='Null New Recovered', datasource_id=None, sql=None, depends_on=['08327437-2a70-49bb-9676-8e63f540eb84'], parent_actions=[DomoDataflow_Action(id='08327437-2a70-49bb-9676-8e63f540eb84', type='ValueMapper', name='Null Recovered', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])])])]), DomoDataflow_Action(id='2d699db0-8a70-4671-837e-3b9fd03152c8', type='ConcatFields', name='State | County', datasource_id=None, sql=None, depends_on=['17e224ee-3f06-4ad1-ad6a-1226af11f5d9'], parent_actions=[DomoDataflow_Action(id='17e224ee-3f06-4ad1-ad6a-1226af11f5d9', type='WindowAction', name='Recovered 2', datasource_id=None, sql=None, depends_on=['0363ec9b-6a88-4914-baa1-80983f03289c'], parent_actions=[DomoDataflow_Action(id='0363ec9b-6a88-4914-baa1-80983f03289c', type='WindowAction', name='Deaths 2', datasource_id=None, sql=None, depends_on=['0d438931-d91a-43ff-8b79-654e6925c4be'], parent_actions=[DomoDataflow_Action(id='0d438931-d91a-43ff-8b79-654e6925c4be', type='WindowAction', name='Confirmed 2', datasource_id=None, sql=None, depends_on=['670ba4cb-9c18-49c2-a372-05d635891bac'], parent_actions=[DomoDataflow_Action(id='670ba4cb-9c18-49c2-a372-05d635891bac', type='GroupBy', name='County Summary', datasource_id=None, sql=None, depends_on=['b5055499-0d69-4273-aedf-c02c0ed96ea7'], parent_actions=[DomoDataflow_Action(id='b5055499-0d69-4273-aedf-c02c0ed96ea7', type='LoadFromVault', name='DOMO US County Covid Time Series Tracker Data', datasource_id='1225e98f-ea61-47e0-bc44-36b38725c280', sql=None, depends_on=None, parent_actions=None)])])])])])])])])], version_id=None, version_number=None, versions=None, History=DomoDataflow_History(execution_history=None), Lineage=DomoLineage(parent_type='DATAFLOW', parent_id=9))
import pandas as pd


async def generate_version_action_pdf(domo_dataflow):
    dataflow_versions = await domo_dataflow.get_versions()

    df = pd.DataFrame(
        [
            {
                "dataflow_id": dataflow_version.id,
                "dataflow_version": dataflow_version.version_id,
                **domo_action.__dict__,
            }
            for dataflow_version in dataflow_versions
            for domo_action in dataflow_version.actions
        ]
    )

    df.drop(columns=["parent_actions", "datasource_id", "sql"], inplace=True)
    df.rename(columns={"id": "tile_id", "type": "tile_type"}, inplace=True)

    return df


action_df = await generate_version_action_pdf(domo_dataflow)
action_df[0:5]
dataflow_id dataflow_version tile_id tile_type name depends_on
0 9 89 0e192d7e-280b-4c4d-bde2-f0f3adb1e213 LoadFromVault DOMO Covid Current Snapshot Tracker Data None
1 9 89 96d04e4b-dc72-479c-b84b-ad0b74ada085 LoadFromVault DOMO Covid Time Series Tracker Data None
2 9 89 a1d07083-d1ca-41e9-8be2-f13596df03c3 ValueMapper Value Mapper [96d04e4b-dc72-479c-b84b-ad0b74ada085]
3 9 89 6e3ec9a4-470b-4fe4-8e8a-bd954b681df4 DateCalculator Days Since... [0e192d7e-280b-4c4d-bde2-f0f3adb1e213]
4 9 89 59e6226d-507f-4cff-86b1-f024499173aa NumericCalculator Resolved Cases [6e3ec9a4-470b-4fe4-8e8a-bd954b681df4] 
async def generate_action_stats_df(domo_dataflow):
    await domo_dataflow.History.get_execution_history(maximum=10)

    df = pd.DataFrame(
        [
            {
                "dataflow_version": domo_history.dataflow_version,
                "dataflow_id": domo_history.dataflow_id,
                "dataflow_begin_time": domo_history.begin_time,
                **domo_action.__dict__,
            }
            for domo_history in domo_dataflow.History.execution_history
            for domo_action in domo_history.action_results
        ]
    )

    df.rename(columns={"id": "tile_id", "type": "tile_type"}, inplace=True)

    return df

stats_df = None

try:
    stats_df = await generate_action_stats_df(domo_dataflow)

except Exception as e:
    print(e)
    
stats_df
dataflow_version dataflow_id dataflow_begin_time tile_id tile_type name is_success rows_processed begin_time end_time duration_in_sec
0 89 9 2025-01-30 21:43:29 0e192d7e-280b-4c4d-bde2-f0f3adb1e213 DataHubManifestLoaderAction None True 315 2025-01-30 21:43:39.122 2025-01-30 21:43:40.314 1.192
1 89 9 2025-01-30 21:43:29 96d04e4b-dc72-479c-b84b-ad0b74ada085 DataHubManifestLoaderAction None True 389096 2025-01-30 21:43:39.122 2025-01-30 21:43:47.351 8.229
2 89 9 2025-01-30 21:43:29 a1d07083-d1ca-41e9-8be2-f13596df03c3 ValueMapper None True 389096 2025-01-30 21:43:40.215 2025-01-30 21:43:47.351 7.136
3 89 9 2025-01-30 21:43:29 6e3ec9a4-470b-4fe4-8e8a-bd954b681df4 DateCalculator None True 315 2025-01-30 21:43:40.215 2025-01-30 21:43:40.232 0.017
4 89 9 2025-01-30 21:43:29 59e6226d-507f-4cff-86b1-f024499173aa NumericCalculator None True 315 2025-01-30 21:43:40.215 2025-01-30 21:43:40.232 0.017
... ... ... ... ... ... ... ... ... ... ... ...
465 89 9 2025-01-30 19:47:01 17e224ee-3f06-4ad1-ad6a-1226af11f5d9 WindowAction None True 3207 2025-01-30 19:47:34.314 2025-01-30 19:47:34.335 0.021
466 89 9 2025-01-30 19:47:01 2d699db0-8a70-4671-837e-3b9fd03152c8 ConcatFields None True 3207 2025-01-30 19:47:34.315 2025-01-30 19:47:34.335 0.020
467 89 9 2025-01-30 19:47:01 64244d26-fc99-459b-966a-ceb3f412ed31 MergeJoin None True 3427400 2025-01-30 19:47:13.127 2025-01-30 19:47:41.468 28.341
468 89 9 2025-01-30 19:47:01 5347a8d3-48de-4799-af32-311ba4936c23 SelectValues None True 3424193 2025-01-30 19:47:34.413 2025-01-30 19:47:41.468 7.055
469 89 9 2025-01-30 19:47:01 31d9273c-3bf1-4046-8594-1bec09a0f83f PublishToVault None True 3424193 2025-01-30 19:47:34.413 2025-01-30 19:47:42.093 7.680

470 rows × 11 columns

def combine_execution_plan_with_stats_df(action_df, stats_df):
    stats_df.drop(columns=["tile_type", "name"], inplace=True)

    df = pd.merge(
        action_df,
        stats_df,
        on=["dataflow_version", "dataflow_id", "tile_id"],
        how="outer",
    )

    return df


combine_df = combine_execution_plan_with_stats_df(action_df.copy(), stats_df.copy())

print(len(combine_df))
combine_df[:10]
931
dataflow_id dataflow_version tile_id tile_type name depends_on dataflow_begin_time is_success rows_processed begin_time end_time duration_in_sec
0 9 20 008ac1ce-4143-420f-93a7-9536ea986fc5 WindowAction Rank & Window [e667577a-8c73-4677-8022-8bf3f3e7a72e] NaT NaN NaN NaT NaT NaN
1 9 20 02a1f8dd-2b0a-4193-9c54-8d4fc19261cc DateCalculator Snapshot Age 1 [250bf67d-8882-4078-a7d4-aa6dda1a1635] NaT NaN NaN NaT NaT NaN
2 9 20 0362dd20-2039-403d-a249-94e2ce716aed Constant Today [18626a7b-c1a7-4fb4-bcc0-7e50ebd7e763] NaT NaN NaN NaT NaT NaN
3 9 20 06f8d60b-8b84-474d-91de-abcaefe10abf SelectValues DIM_Country (Join) [0e783798-e39f-49f2-ac42-70cd82ffd611] NaT NaN NaN NaT NaT NaN
4 9 20 08327437-2a70-49bb-9676-8e63f540eb84 ValueMapper Null Recovered 2 [5da719b4-d4c6-4dfc-a928-38312de82df8] NaT NaN NaN NaT NaT NaN
5 9 20 0c791afe-0acb-4821-8781-ddd5d51c850a WindowAction Recovered [2037eb8f-c88c-4d9f-8d14-ae591a27b627] NaT NaN NaN NaT NaT NaN
6 9 20 0e192d7e-280b-4c4d-bde2-f0f3adb1e213 LoadFromVault DOMO Covid Current Snapshot Tracker Data None NaT NaN NaN NaT NaT NaN
7 9 20 0e783798-e39f-49f2-ac42-70cd82ffd611 UnionAll Append New Values [3ea82c4a-1da1-4c37-b3e5-ea77a6ba035d, 52b67a4... NaT NaN NaN NaT NaT NaN
8 9 20 1689d811-85eb-4e3a-993d-2e59419e2236 SelectValues DIM Table [d6423ad7-938f-428e-a773-c8f2f257de07] NaT NaN NaN NaT NaT NaN
9 9 20 16bae147-462b-4547-94b2-8075aab0a2fb WindowAction Deaths 1 [551ebf46-d0ac-4210-83cd-a50049b2b61d] NaT NaN NaN NaT NaT NaN 
def explode_parents(df):
    """
    1. generates one row for each parent in "depends_on"
    2. joins parents stats to df
    3. stores dataflow_begin_time if there is no parent
    """

    df["dependencies"] = df["depends_on"]
    explode_df = df.explode("depends_on")

    parents_df = df[
        [
            "dataflow_version",
            "dataflow_id",
            "tile_id",
            "tile_type",
            "name",
            "end_time",
            "rows_processed",
        ]
    ].rename(
        columns={
            "tile_id": "parent_tile_id",
            "tile_type": "parent_tile_type",
            "name": "parent_tile_name",
            "end_time": "parent_end_time",
            "rows_processed": "parent_rows_processed",
        }
    )

    explode_df = pd.merge(
        explode_df,
        parents_df,
        left_on=["dataflow_version", "dataflow_id", "depends_on"],
        right_on=["dataflow_version", "dataflow_id", "parent_tile_id"],
        how="left",
    )

    explode_df["parent_end_time"] = explode_df[["begin_time", "parent_end_time"]].max(
        axis=1
    )

    explode_df["actual_duration_in_sec"] = (
        explode_df["end_time"] - explode_df["parent_end_time"]
    ).dt.total_seconds()

    explode_df = explode_df[
        [
            "dataflow_id",
            "dataflow_version",
            "tile_id",
            "tile_type",
            "name",
            "rows_processed",
            "begin_time",
            "end_time",
            "duration_in_sec",
            "parent_end_time",
            "actual_duration_in_sec",
            "dependencies",
            "parent_tile_id",
            "parent_tile_type",
            "parent_tile_name",
            "parent_rows_processed",
        ]
    ]

    explode_df["parent_tile_id"].fillna("start", inplace=True)

    return explode_df


explode_df = explode_parents(combine_df.copy())
explode_df[0:10]
/tmp/ipykernel_8494/2268720893.py:68: FutureWarning: A value is trying to be set on a copy of a DataFrame or Series through chained assignment using an inplace method.
The behavior will change in pandas 3.0. This inplace method will never work because the intermediate object on which we are setting values always behaves as a copy.

For example, when doing 'df[col].method(value, inplace=True)', try using 'df.method({col: value}, inplace=True)' or df[col] = df[col].method(value) instead, to perform the operation inplace on the original object.


  explode_df["parent_tile_id"].fillna("start", inplace=True)
dataflow_id dataflow_version tile_id tile_type name rows_processed begin_time end_time duration_in_sec parent_end_time actual_duration_in_sec dependencies parent_tile_id parent_tile_type parent_tile_name parent_rows_processed
0 9 20 008ac1ce-4143-420f-93a7-9536ea986fc5 WindowAction Rank & Window NaN NaT NaT NaN NaT NaN [e667577a-8c73-4677-8022-8bf3f3e7a72e] e667577a-8c73-4677-8022-8bf3f3e7a72e UnionAll Append Unused DIM Countries NaN
1 9 20 02a1f8dd-2b0a-4193-9c54-8d4fc19261cc DateCalculator Snapshot Age 1 NaN NaT NaT NaN NaT NaN [250bf67d-8882-4078-a7d4-aa6dda1a1635] 250bf67d-8882-4078-a7d4-aa6dda1a1635 NumericCalculator Active Cases 2 NaN
2 9 20 0362dd20-2039-403d-a249-94e2ce716aed Constant Today NaN NaT NaT NaN NaT NaN [18626a7b-c1a7-4fb4-bcc0-7e50ebd7e763] 18626a7b-c1a7-4fb4-bcc0-7e50ebd7e763 Filter Countries Still Listed NaN
3 9 20 06f8d60b-8b84-474d-91de-abcaefe10abf SelectValues DIM_Country (Join) NaN NaT NaT NaN NaT NaN [0e783798-e39f-49f2-ac42-70cd82ffd611] 0e783798-e39f-49f2-ac42-70cd82ffd611 UnionAll Append New Values NaN
4 9 20 08327437-2a70-49bb-9676-8e63f540eb84 ValueMapper Null Recovered 2 NaN NaT NaT NaN NaT NaN [5da719b4-d4c6-4dfc-a928-38312de82df8] 5da719b4-d4c6-4dfc-a928-38312de82df8 ValueMapper Null Deaths 2 NaN
5 9 20 0c791afe-0acb-4821-8781-ddd5d51c850a WindowAction Recovered NaN NaT NaT NaN NaT NaN [2037eb8f-c88c-4d9f-8d14-ae591a27b627] 2037eb8f-c88c-4d9f-8d14-ae591a27b627 WindowAction Deaths NaN
6 9 20 0e192d7e-280b-4c4d-bde2-f0f3adb1e213 LoadFromVault DOMO Covid Current Snapshot Tracker Data NaN NaT NaT NaN NaT NaN None start NaN NaN NaN
7 9 20 0e783798-e39f-49f2-ac42-70cd82ffd611 UnionAll Append New Values NaN NaT NaT NaN NaT NaN [3ea82c4a-1da1-4c37-b3e5-ea77a6ba035d, 52b67a4... 3ea82c4a-1da1-4c37-b3e5-ea77a6ba035d Constant Flag New Values NaN
8 9 20 0e783798-e39f-49f2-ac42-70cd82ffd611 UnionAll Append New Values NaN NaT NaT NaN NaT NaN [3ea82c4a-1da1-4c37-b3e5-ea77a6ba035d, 52b67a4... 52b67a4e-c879-432d-95f4-ccf64475f1b7 SelectValues Up to Date Covid + Existing Webform Info NaN
9 9 20 0e783798-e39f-49f2-ac42-70cd82ffd611 UnionAll Append New Values NaN NaT NaT NaN NaT NaN [3ea82c4a-1da1-4c37-b3e5-ea77a6ba035d, 52b67a4... 97044bf5-caa3-4420-b40f-9002d836d5c5 SelectValues Existing Webform Info - No Longer in Covid NaN 
def calculate_average(df):
    """calculates average execution time for each tile, differentiating by reported duration_in_sec vs actual_duration which assumes an upstream parent"""

    return df.groupby(
        ["dataflow_id", "dataflow_version", "tile_id", "parent_tile_id"]
    ).agg(
        {
            "name": "first",
            "tile_type": "first",
            "parent_tile_name": "first",
            "parent_tile_type": "first",
            "duration_in_sec": "mean",
            "actual_duration_in_sec": "mean",
            "rows_processed": "mean",
            "parent_rows_processed": "mean",
        }
    )


calculate_average(explode_df.copy())
name tile_type parent_tile_name parent_tile_type duration_in_sec actual_duration_in_sec rows_processed parent_rows_processed
dataflow_id dataflow_version tile_id parent_tile_id
9 20 008ac1ce-4143-420f-93a7-9536ea986fc5 e667577a-8c73-4677-8022-8bf3f3e7a72e Rank & Window WindowAction Append Unused DIM Countries UnionAll NaN NaN NaN NaN
02a1f8dd-2b0a-4193-9c54-8d4fc19261cc 250bf67d-8882-4078-a7d4-aa6dda1a1635 Snapshot Age 1 DateCalculator Active Cases 2 NumericCalculator NaN NaN NaN NaN
0362dd20-2039-403d-a249-94e2ce716aed 18626a7b-c1a7-4fb4-bcc0-7e50ebd7e763 Today Constant Countries Still Listed Filter NaN NaN NaN NaN
06f8d60b-8b84-474d-91de-abcaefe10abf 0e783798-e39f-49f2-ac42-70cd82ffd611 DIM_Country (Join) SelectValues Append New Values UnionAll NaN NaN NaN NaN
08327437-2a70-49bb-9676-8e63f540eb84 5da719b4-d4c6-4dfc-a928-38312de82df8 Null Recovered 2 ValueMapper Null Deaths 2 ValueMapper NaN NaN NaN NaN
... ... ... ... ... ... ... ... ... ... ...
89 d652deb2-cd3e-462d-9627-2f72425e05cf 08327437-2a70-49bb-9676-8e63f540eb84 Null New Recovered ValueMapper Null Recovered ValueMapper 22.6663 -1167.80173 3424193.0 3424193.0
dac9af4e-a203-47f5-9493-ec46d834a51f cebf2fb3-75e3-48ee-bfe5-2af9927cb581 Resolved Cases 2 NumericCalculator Null or 0 Long ValueMapper 22.5999 -1167.83604 3424193.0 3424193.0
dc5a2d0c-3bdf-4e94-a07a-7ff4709acc1f 1d3e790a-dabf-45ba-849e-74996d7a03c9 Active Cases 1 NumericCalculator Resolved Cases 1 NumericCalculator 7.3271 -1174.59802 389096.0 389096.0
eeecc67b-34c4-4929-a4e3-34058aba039a 43029ef0-9519-49c6-80c2-2f885e662221 Ranks 1 SelectValues Recovered 1 WindowAction 0.0100 -1177.95880 60.0 60.0
fe46f53d-d10e-4e1e-b341-4d18f565e83b d652deb2-cd3e-462d-9627-2f72425e05cf Null or 0 Lat ValueMapper Null New Recovered ValueMapper 22.6660 -1167.80185 3424193.0 3424193.0

551 rows × 8 columns

def get_action_list(domo_dataflow: dmdf.DomoDataflow):
    return [
        {
            "dataflow_id": domo_dataflow.id,
            "datafow_name": domo_dataflow.name,
            "action_type": domo_action.type,
        }
        for domo_action in domo_dataflow.actions
    ]


get_action_list(domo_dataflow=dataflow_definition_ls[0])
[{'dataflow_id': 131,
  'datafow_name': 'BeastModesGovernance_01_AccumulateHistory',
  'action_type': 'LoadFromVault'},
 {'dataflow_id': 131,
  'datafow_name': 'BeastModesGovernance_01_AccumulateHistory',
  'action_type': 'ExpressionEvaluator'},
 {'dataflow_id': 131,
  'datafow_name': 'BeastModesGovernance_01_AccumulateHistory',
  'action_type': 'PublishToVault'}]
action_ls = [get_action_list(dd_obj) for dd_obj in dataflow_definition_ls]

flat_action_ls = [action for a_list in action_ls for action in a_list]
flat_action_ls[0:5]
[{'dataflow_id': 131,
  'datafow_name': 'BeastModesGovernance_01_AccumulateHistory',
  'action_type': 'LoadFromVault'},
 {'dataflow_id': 131,
  'datafow_name': 'BeastModesGovernance_01_AccumulateHistory',
  'action_type': 'ExpressionEvaluator'},
 {'dataflow_id': 131,
  'datafow_name': 'BeastModesGovernance_01_AccumulateHistory',
  'action_type': 'PublishToVault'},
 {'dataflow_id': 227,
  'datafow_name': 'DDX_Landing Page_QA',
  'action_type': 'LoadFromVault'},
 {'dataflow_id': 227,
  'datafow_name': 'DDX_Landing Page_QA',
  'action_type': 'WindowAction'}]
import pandas as pd

df = pd.DataFrame(flat_action_ls)
df[0:5]
dataflow_id datafow_name action_type
0 131 BeastModesGovernance_01_AccumulateHistory LoadFromVault
1 131 BeastModesGovernance_01_AccumulateHistory ExpressionEvaluator
2 131 BeastModesGovernance_01_AccumulateHistory PublishToVault
3 227 DDX_Landing Page_QA LoadFromVault
4 227 DDX_Landing Page_QA WindowAction 
# df.to_csv("marks_csv.csv")